﻿CREATE PROCEDURE [dbo].[Designation_Update]
@DesignationID uniqueidentifier
, @ModifiedBy uniqueidentifier
, @Description varchar (64)
, @SystemDescription varchar (64)
AS
BEGIN

UPDATE [dbo].[Designation]
SET  [ModifiedBy] = @ModifiedBy
, [Description] = @Description
, [SystemDescription] = @SystemDescription
, [ModifiedDate] = GETDATE()
WHERE [Deleted] = 0
AND [DesignationID] = @DesignationID


END
